import java.sql.*;

public class Main {
    public static void main(String[] args) {

            //1、 加载驱动
            try {
                Class.forName("com.mysql.cj.jdbc.Driver");

                //2、获取连接
                Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/jdbc?characterEncoding=utf-8",
                        "root","130258");

                //3、编写sql语句
                String sql = "select * from user";

                //4、预处理sql  .var
                PreparedStatement preparedStatement = conn.prepareStatement(sql);

                //5、如果有参数，设置参数

                //6、执行sql语句
                ResultSet resultSet = preparedStatement.executeQuery();

                // 7、如果是查询就遍历结果/如果是增删改 判断是否成功
                while (resultSet.next()) {
                    int id = resultSet.getInt(1);
                    String name = resultSet.getString(2);
                    String pass = resultSet.getString(3);
                    System.out.println(new StringBuilder().append(id).append("----").append(name).append("----").append(pass).toString());
                }
                // 8、返回视图

            } catch (ClassNotFoundException e) {
                throw new RuntimeException(e);
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }


        }

    }

